﻿CREATE TABLE [dbo].[Forms] (
    [FormKey]              UNIQUEIDENTIFIER NOT NULL,
    [ShortPath]            NVARCHAR (12)    NULL,
    [UserKey]              UNIQUEIDENTIFIER NOT NULL,
    [AutoResponderKey]     UNIQUEIDENTIFIER NULL,
    [Name]                 NVARCHAR (50)    NOT NULL,
    [IsRedirectOnComplete] BIT              NOT NULL,
    [CompletionMessage]    TEXT             NULL,
    [AlertOnComplete]      BIT              NOT NULL,
    [RedirectURL]          NVARCHAR (255)   NULL,
    [IsRemoved]            BIT              NOT NULL,
    [LastModified]         DATETIME2 (7)    NULL,
    [CreatedOn]            DATETIME2 (7)    NOT NULL
);

